StoredValueFundSaleLineItem

Entity Definition

Logical Name : StoredValueFundSaleLineItem
Physical Name : TR_LTM_STRD_VL_FND_SL

TheStoredValueFundSale captures the sale of a gift card, gift certificate or other kind of stored value instrument to a customer. It corresponds to POSLOG6 StoredValueFundSale element. Retailers may sell their own stored value instruments or thrid party stored value instruments (e.g. Blackhawk Giftcards, VISA Giftcards, etc.). When retailers sell a stored value instrument that they "own", they credit stored value unearned revenue or a similar liability account. The retailer has collected a payment and in effect holds it in the stored value instrument for subsequent redemption by the customer. For third party stored value instruments, the third party, not the retailer has the unearned revenue liability. In this case the retailer earns a fee or some kind of margin on the 3rd party stored value instrument and may treat it as another item. In addition to customers explicitly purchasing stored value instruments, a retailer may give them away as part of a promotion (e.g. "free" $10 giftcard when you buy $100 or more worth of merchandise). In this scenario (assuming the retailer "owns" the giftcard), the retailer will debit discount, credit unearned stored value revenue liability and book the merchandise, tax and tender line items as usual.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
RetailTransactionLineItemSequenceNumber (FK)(PK) The sequence number of line item within the context of this RetailTransaction. IC_LN_ITM LineNumber smallint
StoredValueInstrumentID (FK) A token ID for a StoredValueInstrument ID_STRD_VL_INSTRMNT Identity integer StoredValueInstrument(DO_STRD_VL_INSTRMNT)
EntryMethodCode The method used to enter the stored value instrument ID and account information. Sample values: SCAN KEYED Others that a retailer determines are required. CD_ENR_MTH Code varchar(20)

Relationships

Parent Entity Verb Phrase Child Entity
StoredValueInstrument sales recorded by StoredValueFundSaleLineItem

Logical Views containing StoredValueFundSaleLineItem

Logical View
Logical 01420 - Prepaid and Stored Value Payment Instruments
Logical 02300 - Retail Transaction - Macro View
Logical 02310 - Retail Transaction - Item Sale View
Logical 02311 - Retail Transaction Item KIT Sale View
Logical 02390 - Retail Transaction - Stored Value Instrument
Logical 04100 - Financial Ledger - Retail Transaction View
Logical 07040 - Customer Segment Dependent Behavior